﻿/********************************************************************************************************************
* Author:	Christos Polydorou																						*
* Email:	std04237@di.uoa.gr																						*
* Purpose:	This script is used in order to create the stored procedure "usp_getDeletedCategories" that returns		*
*			all deleted categories.																								*
********************************************************************************************************************/

CREATE PROCEDURE [dbo].[usp_getDeletedCategories]
AS
	SELECT Categories.ID, Categories.name
	FROM Categories
	WHERE Categories.IsDeleted != 0
RETURN 0